﻿DROP VIEW IF EXISTS `open_vt_spkc`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `open_vt_spkc` AS select `open_goods`.`goods_sn` AS `goods_sn`,`open_goods`.`goods_name` AS `goods_name`,`open_color`.`color_name` AS `color_name`,`open_color`.`color_code` AS `color_code`,`open_size`.`size_name` AS `size_name`,`open_size`.`size_code` AS `size_code`,`open_goods_inventory`.`goods_number_actual` AS `goods_number_actual`,`open_goods_inventory`.`goods_number_available` AS `goods_number_available` from (((`open_goods_inventory` left join `open_goods` on((`open_goods`.`goods_id` = `open_goods_inventory`.`goods_id`))) left join `open_color` on((`open_color`.`color_id` = `open_goods_inventory`.`color_id`))) left join `open_size` on((`open_size`.`size_id` = `open_goods_inventory`.`size_id`)));